package com.moran.beetlsql.learn.mapper.test;

import com.moran.beetlsql.learn.bean.WebsitesBean;
import org.beetl.sql.mapper.BaseMapper;
import org.beetl.sql.mapper.annotation.Sql;
import org.beetl.sql.mapper.annotation.SqlResource;

import java.util.List;
/**
 * @Description
 * @Author wnf
 * @Date 2025-07-10
 */
@SqlResource("test.TestWebsitesMapper")
public interface WebsitesMapper extends BaseMapper {
    List<WebsitesBean> queryWebsitesList();

    @Sql("select w.id, w.alexa, w.name, w.url, w.country, a.count, a.date from websites w inner join access_log a on a.site_id = w.id")
    List<WebsitesBean> queryWebsitesLogList();
}
